<?php

return array(
	'install'=>"
		CREATE TABLE IF NOT EXISTS `w_m_chepai` (
			`id` INT(11) NOT NULL AUTO_INCREMENT,
			`user_id` INT(11) NOT NULL,
			`chepai` VARCHAR(50) NOT NULL,
			`addtime` INT(11) NOT NULL,
			PRIMARY KEY (`id`),
			INDEX `user_id` (`user_id`)
		)
		COMMENT='车牌'
		COLLATE='utf8_general_ci'
		ENGINE=InnoDB
		AUTO_INCREMENT=1;
		
		CREATE TABLE IF NOT EXISTS `w_m_chuxing` (
			`id` INT(11) NOT NULL AUTO_INCREMENT,
			`user_id` INT(11) NOT NULL COMMENT '用户',
			`chepai` VARCHAR(50) NOT NULL COMMENT '车牌',
			`date` DATE NOT NULL COMMENT '日期',
			`month` VARCHAR(50) NOT NULL COMMENT '年月',
			`addtime` INT(11) NOT NULL,
			PRIMARY KEY (`id`),
			INDEX `user_id` (`user_id`)
		)
		COMMENT='出行记录'
		COLLATE='utf8_general_ci'
		ENGINE=InnoDB
		AUTO_INCREMENT=1;
	",
	'uninstall'=>"
		DROP TABLE IF EXISTS `w_m_chepai`;
		DROP TABLE IF EXISTS `w_m_chuxing`;
	"
);